﻿CREATE TABLE [dbo].[BillOrderItem]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [BillOrderId] INT NOT NULL, 
    [Type] NVARCHAR(50) NULL, 
    [Name] NVARCHAR(200) NULL, 
    [Account] VARCHAR(50) NULL, 
    [Unit] NVARCHAR(50) NULL, 
    [Money] NVARCHAR(50) NULL, 
    [ItemPrice] NVARCHAR(50) NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'缴费订单Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'BillOrderId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目费用类型',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'Type'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'Name'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目数量',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'Account'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目单位',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'Unit'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目小计',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'Money'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'项目单价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'BillOrderItem',
    @level2type = N'COLUMN',
    @level2name = N'ItemPrice'